Create the Datasets

Four datasets will be created and named empl_phone, empl_email, Emergency, and Dependents. This procedure will walk you through creating the dataset for empl_phone. Repeat the procedure for the remaining three datasets.

To add a dataset:

  1. Click the Show/hide Dataset icon Show hide dataset icon on the Band Report Editor Toolbar.  This will show the dataset pane on the right side of the screen.The Banded Report Editor showing the dataset pane and the plus icon for adding a dataset.
  2. Click the blue plus icon Blue plus icon on the right to bring up the following dialog box in which you identify the properties of the dataset.
  3. Name the dataset empl_phone and set the Master Dataset to ArgosData(main). ArgosData(main) is the dataset containing the Main Report query. 
    Edit Dataset dialog where the Dataset is built.
  4. Click the Build Query icon Build query icon to bring up the Build Query dialog box. (This dialog builds the SQL query for your dataset.)
  5. Click the Show Tables button, then select the Employee_Phone table. 
    Build Query dialog with the selected fields in the Employee phone table.
  6. In the Employee_Phone table, double-click on the phone_type and phone_number fields which will place them into the tables at the bottom of the Build Query window.
    The visible fields (select) tab at the bottom of the screen. The two fields selected are phone type and phone number. The table name, field name, and data type are listed for each selection. The data type for both fields, in this case, is string.

You will need to build the conditional (WHERE) clause next. The WHERE clause is utilized to link the emp_id field in this table to the emp_id field within the Employees table in the Main DataBlock.

  1. Click on the Conditional Fields (WHERE) tab.
    Conditional Fields (WHERE) tab at the bottom of the Build Query screen. Double click or drag fields into the boxes on this tab. The boxes include and/or, which is a box for Boolean operators; table; field; and condition.
  2. In the Employee_Phone table, double-click emp_id to populate the and/or, table, and field fields.
    Conditional fields with and/or, table, and field filled out.
  3. In the Condition field, click the ellipses button elllipses button to open the SQL Editor window. (This is where you link the emp_id field in this table to the emp_id field within the Employees table in the Main DataBlock.)
    S Q L editor window. The text field is empty. The toolbar for adding variables, fields, and operators is at the bottom of the window.
  4. Click the variable button Insert variable button to launch the Pick a variable dialog.
  5. Click the plus icon next to ArgosData to expand it.
  6. Select emp_id from the list of variables.
    Pick a variable window. Argos Data is expanded and emp i d is selected.
  7. Click OK to return to the SQL Editor. The variable ArgosData.emp_id is now in the text field of the SQL Editor.
    S Q L Editor with the variable argos data emp i d entered in the text field.
  8. Click OK to return to the Build Query Window. All of the conditional fields are now populated.
    Build query dialog with the Conditional fields (where) tab selected. All of the conditional fields have been filled out. The and/or field has and filled in; the table field has the employee phone table; the Field field has the emp i d field; and the condition field has the emp i d field from the argos data table.
  9. Click OK to return to the Edit Dataset dialog. You will see the completed SQL query in the SQL text field.
    Edit dataset properties dialog with the completed query.
  10. Click OK to exit the dialog.
  11. Click Yes to validate the query, then enter a test value for emp_id when prompted.

After the query is validated, you will be returned to the Banded Report Editor. The dataset you just created now appears in the Dataset pane on the right side of the window.

The Banded Report Editor with the newly created dataset.

Use the above procedure to create the remaining datasets. Click the blue plus icon Blue plus icon to start creating the next dataset.

When you have finished creating the datasets, they will be displayed in the dataset pane on the Band Report Editor.

Dataset pane on the Band Report Editor. The pane is showing all four created datasets. The datasets are the employee phone, employee email, emergency, and dependents.